In the previous parts of these MySQL optimization series, we told you how query optimization works on a high level, then walked you through how you should optimize queries that insert, read, or update data. Remember the laws of physics? “What goes up, must come down”? Translated into database terms, that means “the data that …
The post Optimizing MySQL: Deleting Data appeared first on Simple Talk.
Learn how to use and format the treemap visual in Power BI in this step-by-step tutorial.
In this article, we look at how to build a slicer visual in Power BI and how to create a custom sort order for the slicer values.
On the era of SaaS, I see many companies hiring a lot of SaaS services. They create a dependency on them for their production operations. It may seems the company is saving work and being modern when joining e-commerce portals with SaaS ERP’s and other online providers. Event-driven architectures are modern, aren’t them? They can …
The post Data and SaaS : Who owns your company’s Data? appeared first on Simple Talk.
Learn how to infuse Azure SQL data with retrieval augment generation (RAG) which allows large language models (LLMs) such as GPT to provide answers to complex questions.
Learn how to use the AGDiag tool to troubleshoot and analyze SQL Server Always On Availability Group issues.
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i.e. a capacity administrator. Of course some of these roles may be covered …
The post PowerBI premium capacity administration: dataset monitoring and tuning appeared first on Simple Talk.
In this article, learn about the Metrics App and Data Activator for Microsoft Fabric for monitoring and taking necessary administrative action to control Fabric capacity.
Containerization has removed boundaries that limit developers from working on one application using different systems. Thus, boosting developer collaboration and speeding the application deployment process. Containerization involves bundling and packaging applications into containers that have all the necessary dependencies and tools for compiling an application on any operating system. Containers enable the coexistence of legacy …
The post A Quick Guide on How to Containerize Your Application Using Docker appeared first on Simple Talk.
Learn about the SQL Server BULK INSERT command and how to use it to import text data in a SQL Server database table.
Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner.
In this article, we look at various ways to use SQL SELECT TOP to return a certain number or percentage of rows when selecting data.
In this tutorial, we delve into critical aspects of data quality management when working with time-series data and we will use Python to demonstrate.
In this article, we walk through the syntax for creating SQL Server local and global temporary tables and some use cases for when and how to use them.
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach. One of the benefits of having a more code-based approach in data pipelines is that it has become easier to build metadata driven pipelines. What does this mean exactly? Say for example you need to …
The post How to Build Metadata Driven Pipelines in Microsoft Fabric appeared first on Simple Talk.
Oracle database is a complex system and objects are interrelated and have dependencies. Like a package may depend on a certain Oracle table, view or synonym. So objects may go invalid in case of deployments of new objects, alter table commands, packages, views, and synonyms. Now let’s find out how to find the invalid objects …
How to Compile Invalid objects in Oracle Read More »
The post How to Compile Invalid objects in Oracle appeared first on Techgoeasy.
In this article, learn how to integrate Power BI reports with data from Azure Synapse Analytics in this step-by-step tutorial.
In this article, we will explain how the OPTIMIZE and VACUUM commands can assist in maintaining the tables in the Microsoft Fabric Lakehouse.
Get ready for and pass the Microsoft Azure Administrators AZ-104 Exam with this study guide with lots of useful resources.
In this article, we look at how to use GitHub Actions to deploy database changes after a commit to the Main branch in a GitHub repository.
Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.
In this tip, we'll discuss the various maintenance options for ensuring performance doesn't degrade for lakehouse tables when using Microsoft Fabric.
In this article, we take a look at SQL LogScout which is a log analysis tool that can help you troubleshoot SQL Server errors by using the available log files on the system.
In this article, we look at how to read data stored in a lake database using Azure Synapse Analytics to help reduce overall Azure costs.
SQL Server Agent can be a very useful to automate and schedule SQL Server tasks. In this article, we look at how to get it set up, create jobs, and send email notifications.
In this article, we look at how to visualize time-series data using Excel with a walkthrough of how this is done with a sample dataset.
Learn about the concept of serverless microservices and how this architecture could be used to support your applications.
Learn how to use the Python library Prophet for time series forecasting to predict a target variable over a period.